module.exports = {
    host: '106.13.233.100', // mysql所在的主机，本地的话就是 127.0.0.1 或者 localhost, 如果数据库在服务器上，就写服务器的ip
    port: '3306',
    user: 'root', // mysql的用户名
    password: 'rootwwj', // mysql的密码
    multipleStatements: true, // 多语句执行
    database: 'testdb22', // 你要连接那个数据库
    tables_create: [
        `DROP TABLE IF EXISTS users;
        CREATE TABLE users  (
          id int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一id',
          userName varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
          password varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
          createDate datetime NULL DEFAULT NULL COMMENT '创建时间',
          changeDate datetime NULL DEFAULT NULL COMMENT '最后一次修改时间',
          PRIMARY KEY (id) USING BTREE
        ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;`,
        `DROP TABLE IF EXISTS employees3;
        CREATE TABLE employees3  (
            id int(11) NULL DEFAULT NULL,
            name varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
            age int(3) NULL DEFAULT NULL,
            city varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
        ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;`,
    ], // 创建数据表命令
    tables_InsetData: [
        `INSERT INTO users VALUES (1, 'wwj', 'wwj', '2022-05-22 00:38:59', '2022-05-28 00:39:04');
        INSERT INTO users VALUES (2, 'zhangsan', '123456', '2022-05-22 00:38:59', '2022-05-28 00:39:04');
        INSERT INTO users VALUES (3, 'lisi', '123456', '2022-05-22 00:38:59', '2022-05-28 00:39:04');`,
    ], // 插入数据命令
}
